<!doctype html><html>
<head>
  <meta http-equiv="content-type" content="text/html; charset=utf-8">
  <title>1-1 会员信息表和订单数据库表，旅客表</title>
  <meta name="generator" content="CherryTree">
  <link rel="stylesheet" href="styles.css" type="text/css" />
</head>
<body><div class="main"><div class="tree">
<p><strong>Index</strong></p>
<p><a href="笔记本--java--项目--ssm综合练习_权限管理.html">ssm综合练习 权限管理</a></p>

<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--1_数据库表预览.html">1 数据库表预览</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--2_maven聚合工程的创建.html">2 maven聚合工程的创建</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--3_产品操作.html">3 产品操作</a></li>
<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--3_产品操作--3-0_数据库创建与表结构.html">3-0 数据库创建与表结构</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--3_产品操作--3-1_创建实体类.html">3-1 创建实体类</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--3_产品操作--3-2_持久层接口.html">3-2 持久层接口</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--3_产品操作--3-3_编写业务层.html">3-3 编写业务层</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--3_产品操作--3-4_web层代码.html">3-4 web层代码</a></li>
<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--3_产品操作--3-4_web层代码--3-4-1_完善__格式化时间和状态.html">3-4-1 完善  格式化时间和状态</a></li>
</ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--3_产品操作--3-5_product-list.jsp页面制作.html">3-5 product-list.jsp页面制作</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--3_产品操作--3-6_添加产品.html">3-6 添加产品</a></li>
</ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作.html">4 订单操作</a></li>
<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作--1_查询所有信息.html">1 查询所有信息</a></li>
<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作--1_查询所有信息--1-1_会员信息表和订单数据库表，旅客表.html">1-1 会员信息表和订单数据库表，旅客表</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作--1_查询所有信息--1-2_实体类.html">1-2 实体类</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作--1_查询所有信息--1-3_dao.html">1-3 dao</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作--1_查询所有信息--1-4_service.html">1-4 service</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作--1_查询所有信息--1-5_controller.html">1-5 controller</a></li>
</ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作--2_分页查询所有.html">2 分页查询所有</a></li>
<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作--2_分页查询所有--2-1_pageHelpe的使用.html">2-1 pageHelpe的使用</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作--2_分页查询所有--2-2_分页查询.html">2-2 分页查询</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作--2_分页查询所有--2-3_视图分页.html">2-3 视图分页</a></li>
</ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--4_订单操作--3_查询详情.html">3 查询详情</a></li>
</ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限.html">5 权限</a></li>
<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--1_springSecurity.html">1 springSecurity</a></li>
<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--1_springSecurity--1_配置文件登录基础使用.html">1 配置文件登录基础使用</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--1_springSecurity--2_自定义页面.html">2 自定义页面</a></li>
</ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--2_使用springSecurity数据库验证登录.html">2 使用springSecurity数据库验证登录</a></li>
<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--2_使用springSecurity数据库验证登录--1_创建数据库和实体类.html">1 创建数据库和实体类</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--2_使用springSecurity数据库验证登录--2_修改web.xml文件.html">2 修改web.xml文件</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--2_使用springSecurity数据库验证登录--3_添加springSecurity.xml.html">3 添加springSecurity.xml</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--2_使用springSecurity数据库验证登录--4_service曾接口.html">4 service曾接口</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--2_使用springSecurity数据库验证登录--5_mapper.html">5 mapper</a></li>
</ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--3_查询所有用户.html">3 查询所有用户</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--4_添加用户.html">4 添加用户</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--4-1_添加用户加密.html">4-1 添加用户加密</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--5_权限--4-2_加密密码登录.html">4-2 加密密码登录</a></li>
</ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--6_用户详情.html">6 用户详情</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--7_角色.html">7 角色</a></li>
<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--7_角色--1_添加角色.html">1 添加角色</a></li>
</ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--8_权限查询和添加.html">8 权限查询和添加</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--9_用户和角色的关联.html">9 用户和角色的关联</a></li>
<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--9_用户和角色的关联--1_用户添加角色.html">1 用户添加角色</a></li>
</ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--10_角色关联权限.html">10 角色关联权限</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--11_方法级别的权限控制.html">11 方法级别的权限控制</a></li>
<ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--11_方法级别的权限控制--1_JSR-250.html">1 JSR-250</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--11_方法级别的权限控制--2_secured.html">2 secured</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--11_方法级别的权限控制--3_表达式注解.html">3 表达式注解</a></li>
</ol>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--12_页面使用权限标签.html">12 页面使用权限标签</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--13_AOP切面通知.html">13 AOP切面通知</a></li>
<li><a href="笔记本--java--项目--ssm综合练习_权限管理--14_页面查看日志.html">14 页面查看日志</a></li>
</ol></div>
<div class="page"><h1><b><u>1-1 会员信息表和订单数据库表，旅客表</u></b></h1><br /><br />创建会员信息表<br /><div class="codebox"><div class="codebox">CREATE&nbsp;TABLE&nbsp;member(<br />id&nbsp;varchar2(<span style="color:#ff0044;font-weight:400">32</span>)&nbsp;<span style="color:#ff9d00;font-weight:700">default</span>&nbsp;SYS_GUID()&nbsp;PRIMARY&nbsp;KEY,<br />NAME&nbsp;VARCHAR2(<span style="color:#ff0044;font-weight:400">20</span>),<br />nickname&nbsp;VARCHAR2(<span style="color:#ff0044;font-weight:400">20</span>),<br />phoneNum&nbsp;VARCHAR2(<span style="color:#ff0044;font-weight:400">20</span>),<br />email&nbsp;VARCHAR2(<span style="color:#ff0044;font-weight:400">20</span>)<br />)<br />insert&nbsp;into&nbsp;MEMBER&nbsp;(id,&nbsp;name,&nbsp;nickname,&nbsp;phonenum,&nbsp;email)<br />values&nbsp;('E61D65F673D54F68B0861025C69773DB',&nbsp;'张三',&nbsp;'小三',&nbsp;'<span style="color:#ff0044;font-weight:400">18888888888</span>',&nbsp;'zs@<span style="color:#ff0044;font-weight:400">163</span>.com');</div></div><br /><br />创建订单信息表子<br /><div class="codebox"><div class="codebox">CREATE&nbsp;TABLE&nbsp;orders(<br />id&nbsp;varchar2(<span style="color:#ff0044;font-weight:400">32</span>)&nbsp;<span style="color:#ff9d00;font-weight:700">default</span>&nbsp;SYS_GUID()&nbsp;PRIMARY&nbsp;KEY,<br />orderNum&nbsp;VARCHAR2(<span style="color:#ff0044;font-weight:400">20</span>)&nbsp;NOT&nbsp;NULL&nbsp;UNIQUE,<br />orderTime&nbsp;timestamp,<br />peopleCount&nbsp;INT,<br />orderDesc&nbsp;VARCHAR2(<span style="color:#ff0044;font-weight:400">500</span>),<br />payType&nbsp;INT,<br />orderStatus&nbsp;INT,<br />productId&nbsp;varchar2(<span style="color:#ff0044;font-weight:400">32</span>),<br />memberId&nbsp;varchar2(<span style="color:#ff0044;font-weight:400">32</span>),<br />FOREIGN&nbsp;KEY&nbsp;(productId)&nbsp;REFERENCES&nbsp;product(id),<br />FOREIGN&nbsp;KEY&nbsp;(memberId)&nbsp;REFERENCES&nbsp;member(id)<br />)<br /><br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('<span style="color:#ff0044;font-weight:400">0E7231D</span>C797C486290E8713CA3C6ECCC',&nbsp;'<span style="color:#ff0044;font-weight:400">12345</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span><span style="color:#00117f;font-weight:400">','</span>dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'676C5BD1D35E429A8C2E114939C5685A',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('<span style="color:#ff0044;font-weight:400">5D</span>C6A48DD4E94592AE904930EA866AFA',&nbsp;'<span style="color:#ff0044;font-weight:400">54321</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'676C5BD1D35E429A8C2E114939C5685A',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('<span style="color:#ff0044;font-weight:400">2F</span>F351C4AC744E2092DCF08CFD314420',&nbsp;'<span style="color:#ff0044;font-weight:400">67890</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'12B7ABF2A4C544568B0A7C69F36BF8B7',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('A0657832D93E4B10AE88A2D4B70B1A28',&nbsp;'<span style="color:#ff0044;font-weight:400">98765</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'12B7ABF2A4C544568B0A7C69F36BF8B7',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('E4DD4C45EED84870ABA83574A801083E',&nbsp;'<span style="color:#ff0044;font-weight:400">11111</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'12B7ABF2A4C544568B0A7C69F36BF8B7',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('96CC8BD43C734CC2ACBFF09501B4DD5D',&nbsp;'<span style="color:#ff0044;font-weight:400">22222</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'12B7ABF2A4C544568B0A7C69F36BF8B7',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('<span style="color:#ff0044;font-weight:400">55F</span>9AF582D5A4DB28FB4EC3199385762',&nbsp;'<span style="color:#ff0044;font-weight:400">33333</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'<span style="color:#ff0044;font-weight:400">9F</span>71F01CB448476DAFB309AA6DF9497F',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('CA005CF1BE3C4EF68F88ABC7DF30E976',&nbsp;'<span style="color:#ff0044;font-weight:400">44444</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'<span style="color:#ff0044;font-weight:400">9F</span>71F01CB448476DAFB309AA6DF9497F',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('3081770BC3984EF092D9E99760FDABDE',&nbsp;'<span style="color:#ff0044;font-weight:400">55555</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'<span style="color:#ff0044;font-weight:400">9F</span>71F01CB448476DAFB309AA6DF9497F',<br />'E61D65F673D54F68B0861025C69773DB');</div></div><br /><br />旅客表<br /><div class="codebox"><div class="codebox">CREATE&nbsp;TABLE&nbsp;traveller(<br />id&nbsp;varchar2(<span style="color:#ff0044;font-weight:400">32</span>)&nbsp;<span style="color:#ff9d00;font-weight:700">default</span>&nbsp;SYS_GUID()&nbsp;PRIMARY&nbsp;KEY,<br />NAME&nbsp;VARCHAR2(<span style="color:#ff0044;font-weight:400">20</span>),<br />sex&nbsp;VARCHAR2(<span style="color:#ff0044;font-weight:400">20</span>),<br />phoneNum&nbsp;VARCHAR2(<span style="color:#ff0044;font-weight:400">20</span>),<br />credentialsType&nbsp;INT,<br />credentialsNum&nbsp;VARCHAR2(<span style="color:#ff0044;font-weight:400">50</span>),<br />travellerType&nbsp;INT<br />)<br /><br />insert&nbsp;into&nbsp;TRAVELLER&nbsp;(id,&nbsp;name,&nbsp;sex,&nbsp;phonenum,&nbsp;credentialstype,&nbsp;credentialsnum,&nbsp;travellertype)<br />values&nbsp;('<span style="color:#ff0044;font-weight:400">3F</span>E27DF2A4E44A6DBC5D0FE4651D3D3E',&nbsp;'张龙',&nbsp;<span style="color:#00117f;font-weight:400">'男'</span>,&nbsp;'<span style="color:#ff0044;font-weight:400">13333333333</span>',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,<br />'<span style="color:#ff0044;font-weight:400">123456789009876543</span>',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>);<br />insert&nbsp;into&nbsp;TRAVELLER&nbsp;(id,&nbsp;name,&nbsp;sex,&nbsp;phonenum,&nbsp;credentialstype,&nbsp;credentialsnum,&nbsp;travellertype)<br />values&nbsp;('EE7A71FB6945483FBF91543DBE851960',&nbsp;'张小龙',&nbsp;<span style="color:#00117f;font-weight:400">'男'</span>,&nbsp;'<span style="color:#ff0044;font-weight:400">15555555555</span>',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,<br />'<span style="color:#ff0044;font-weight:400">987654321123456789</span>',&nbsp;<span style="color:#ff0044;font-weight:400">1</span>);</div></div><br /><br />添加模拟数据<br />注意:需要先添加会员信息表的数据<br /><div class="codebox"><div class="codebox"><br /><span style="color:#0088ff;font-weight:400">//会员信息表数据</span><br />insert&nbsp;into&nbsp;MEMBER&nbsp;(id,&nbsp;name,&nbsp;nickname,&nbsp;phonenum,&nbsp;email)<br />values&nbsp;('E61D65F673D54F68B0861025C69773DB',&nbsp;'张三',&nbsp;'小三',&nbsp;'<span style="color:#ff0044;font-weight:400">18888888888</span>',&nbsp;'zs@<span style="color:#ff0044;font-weight:400">163</span>.com');<br /><br /><br /><span style="color:#0088ff;font-weight:400">///////订单表数</span><br /><br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('<span style="color:#ff0044;font-weight:400">0E7231D</span>C797C486290E8713CA3C6ECCC',&nbsp;'<span style="color:#ff0044;font-weight:400">12345</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'676C5BD1D35E429A8C2E114939C5685A',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('<span style="color:#ff0044;font-weight:400">5D</span>C6A48DD4E94592AE904930EA866AFA',&nbsp;'<span style="color:#ff0044;font-weight:400">54321</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'676C5BD1D35E429A8C2E114939C5685A',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('<span style="color:#ff0044;font-weight:400">2F</span>F351C4AC744E2092DCF08CFD314420',&nbsp;'<span style="color:#ff0044;font-weight:400">67890</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'12B7ABF2A4C544568B0A7C69F36BF8B7',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('A0657832D93E4B10AE88A2D4B70B1A28',&nbsp;'<span style="color:#ff0044;font-weight:400">98765</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'12B7ABF2A4C544568B0A7C69F36BF8B7',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('E4DD4C45EED84870ABA83574A801083E',&nbsp;'<span style="color:#ff0044;font-weight:400">11111</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'12B7ABF2A4C544568B0A7C69F36BF8B7',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('96CC8BD43C734CC2ACBFF09501B4DD5D',&nbsp;'<span style="color:#ff0044;font-weight:400">22222</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'12B7ABF2A4C544568B0A7C69F36BF8B7',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('<span style="color:#ff0044;font-weight:400">55F</span>9AF582D5A4DB28FB4EC3199385762',&nbsp;'<span style="color:#ff0044;font-weight:400">33333</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'<span style="color:#ff0044;font-weight:400">9F</span>71F01CB448476DAFB309AA6DF9497F',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('CA005CF1BE3C4EF68F88ABC7DF30E976',&nbsp;'<span style="color:#ff0044;font-weight:400">44444</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'<span style="color:#ff0044;font-weight:400">9F</span>71F01CB448476DAFB309AA6DF9497F',<br />'E61D65F673D54F68B0861025C69773DB');<br />insert&nbsp;into&nbsp;ORDERS&nbsp;(id,&nbsp;ordernum,&nbsp;ordertime,&nbsp;peoplecount,&nbsp;orderdesc,&nbsp;paytype,&nbsp;orderstatus,<br />productid,&nbsp;memberid)<br />values&nbsp;('3081770BC3984EF092D9E99760FDABDE',&nbsp;'<span style="color:#ff0044;font-weight:400">55555</span>',&nbsp;to_timestamp('<span style="color:#ff0044;font-weight:400">02</span>-<span style="color:#ff0044;font-weight:400">03</span>-<span style="color:#ff0044;font-weight:400">2018</span>&nbsp;<span style="color:#ff0044;font-weight:400">12</span>:<span style="color:#ff0044;font-weight:400">00</span>:<span style="color:#ff0044;font-weight:400">00.000000</span>',<br />'dd-mm-yyyy&nbsp;hh24:mi:ss.ff'),&nbsp;<span style="color:#ff0044;font-weight:400">2</span>,&nbsp;'没什么',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,&nbsp;<span style="color:#ff0044;font-weight:400">1</span>,&nbsp;'<span style="color:#ff0044;font-weight:400">9F</span>71F01CB448476DAFB309AA6DF9497F',<br />'E61D65F673D54F68B0861025C69773DB');<br /><br /><span style="color:#0088ff;font-weight:400">//旅客表数据</span><br /><br />insert&nbsp;into&nbsp;TRAVELLER&nbsp;(id,&nbsp;name,&nbsp;sex,&nbsp;phonenum,&nbsp;credentialstype,&nbsp;credentialsnum,&nbsp;travellertype)<br />values&nbsp;('<span style="color:#ff0044;font-weight:400">3F</span>E27DF2A4E44A6DBC5D0FE4651D3D3E',&nbsp;'张龙',&nbsp;<span style="color:#00117f;font-weight:400">'男'</span>,&nbsp;'<span style="color:#ff0044;font-weight:400">13333333333</span>',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,<br />'<span style="color:#ff0044;font-weight:400">123456789009876543</span>',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>);<br />insert&nbsp;into&nbsp;TRAVELLER&nbsp;(id,&nbsp;name,&nbsp;sex,&nbsp;phonenum,&nbsp;credentialstype,&nbsp;credentialsnum,&nbsp;travellertype)<br />values&nbsp;('EE7A71FB6945483FBF91543DBE851960',&nbsp;'张小龙',&nbsp;<span style="color:#00117f;font-weight:400">'男'</span>,&nbsp;'<span style="color:#ff0044;font-weight:400">15555555555</span>',&nbsp;<span style="color:#ff0044;font-weight:400">0</span>,<br />'<span style="color:#ff0044;font-weight:400">987654321123456789</span>',&nbsp;<span style="color:#ff0044;font-weight:400">1</span>);<br /><br /><br /><br /></div></div><br /><br /><br /><br />3FE27DF2A4E44A6DBC5D0FE4651D3D3E</div></div>
</body></html>